home *** CD-ROM | disk | FTP | other *** search
/ The Business Master (3rd Edition) / The Business Master (3rd Edition).iso / files / busition / archtec1 / arch-a41.exe / ARCHITEC.ACS / SOURCE.DOC < prev    next >
Encoding:
Text File  |  1989-03-13  |  6.6 KB  |  175 lines
  1.                         SourceMatσ [TM▌ Custome≥ Filσ Menu
  2.                                  Overview:
  3.  
  4. Thi≤ optioε wil∞ creatσ record≤ iε thσ SourceMatσ [TM▌ Custome≥ Filσ forma⌠ ì
  5. anΣá theεá appenΣ theφ t∩ thσ SourceMatσ [TM▌ Custome≥ filσ iε thσá \SOURC┼ ì
  6. subdirector∙ anΣ drivσ oµ you≥ choice.
  7.  
  8. Optionally¼á yo⌡á caεá ß selec⌠ additiona∞ selectioε criterißá specifiπá t∩ ì
  9. SourceMatσ [TM].
  10.  
  11. Oncσá thσá ne≈ record≤ froφ thi≤ prograφ arσ appendeΣ int∩á thσá SourceMatσ ì
  12. [TM▌á Custome≥ file¼á yo⌡ mus⌠ reinde° thosσ file≤ withiε SourceMatσá [TM]«  ì
  13. T∩ d∩ this¼ brinτ u≡ thσ Maiε Men⌡ oµ Account≤ Receivable¼ versioε 2.0.
  14.  
  15. Iε Account≤ Receivable¼á pres≤ 'F8º t∩ g∩ t∩ Miscellaneous«á   Oncσ iεá thσ ì
  16. Miscellaneou≤á options¼á chosσá #│ t∩ 'Recove≥ Inde° Files.ºá  Afte≥á that¼ ì
  17. selec⌠ optioε ╢ t∩ reinde° thσ custome≥ file.
  18.  
  19.                                ==============
  20.                                |  OPTION 1: |
  21.                                ==============
  22.  
  23.                         1)  Output to Customer File
  24.  
  25.  
  26.   Fields created automatically in SourceMate [TM] file during conversion:
  27.            with fields from which data is drawn in PROSPECT.DBF   
  28.  
  29.  
  30.                           Structure of ARCUS.DBF
  31.  
  32. Structure for database: ARCUS        Corresponding fields in PROSPECT.DBF:
  33.  
  34.  
  35. Structure for database: ARCUS.dbf
  36. Number of data records:       0
  37. Date of last update   : 03/06/89              
  38. Field  Field Name  Type       Width       Dec
  39.     1  FCUSTNO     Character     10        <==== created from PROSPECT field
  40.     2  FCOMPANY    Character     35        <==== from PROSPECT field     
  41.     3  FADDR1      Character     35        <==== from ADDRESS1 field     
  42.     4  FADDR2      Character     35        <==== from ADDRESS2 field         
  43.     5  FCITY       Character     20        <==== from CITY field             
  44.     6  FSTATE      Character     15        <==== from STATE field            
  45.     7  FZIP        Character     10        <==== from ZIP field              
  46. *   8  FSADDR1     Character     35                                          
  47. *   9  FSADDR2     Character     35                 
  48. *  10  FSCITY      Character     20                                              
  49. *  11  FSSTATE     Character     15         
  50. *  12  FSZIP       Character     10        
  51.    13  FCONTACT    Character     30        <==== from FNAME + LNAME  
  52.    14  FTITLE      Character     10
  53.    15  FPHONE      Character     17        <==== from PHONE_1 field 
  54.    16  FPHONE2     Character     17
  55.    17  FTERM       Character     12
  56. è   18  FARACC      Character     14
  57.    19  FCCLASS     Character      1
  58.    20  FSALESPN    Character      5
  59.    21  FTERR       Character      2
  60.    22  FINDUSTRY   Character      2
  61.    23  FTAXCODE1   Character      2
  62.    24  FTAXCODE2   Character      2
  63.    25  FPAYTYPE    Character      1
  64.    26  FPRICECD    Numeric        2
  65.    27  FDISRATE    Numeric        5      2
  66.    28  FTAXRATE1   Numeric        6      3
  67.    29  FTAXRATE2   Numeric        6      3
  68.    30  FCRLIMIT    Numeric       14      2
  69.    31  FOPENCR     Numeric       14      2
  70.    32  FBAL        Numeric       14      2
  71.    33  FCURORDER   Numeric       14      2
  72.    34  FATDSAMT    Numeric       14      2
  73.    35  FYTDSAMT    Numeric       14      2
  74.    36  FMTDSAMT    Numeric       14      2
  75.    37  FQTDSAMT1   Numeric       14      2
  76.    38  FQTDSAMT2   Numeric       14      2
  77.    39  FLPAMT      Numeric       14      2
  78.    40  FLPDATE     Date           8
  79.    41  FNEWDATE    Date           8
  80.    42  FACTIVE     Logical        1
  81.    43  FDISCNT     Logical        1
  82.    44  FFINCHG     Logical        1
  83.    45  FMSHIP      Logical        1
  84.    46  FLOCKED     Logical        1
  85.    47  FRESALENO   Character     16
  86.    48  FVSNO       Character     22
  87.    49  FVSNAME     Character     30
  88.    50  FVSEXPDATE  Character      5
  89.    51  FMCNO       Character     22
  90.    52  FMCNAME     Character     30
  91.    53  FMCEXPDATE  Character      5
  92.    54  FAENO       Character     22
  93.    55  FAENAME     Character     30
  94.    56  FAEEXPDATE  Character      5
  95.    57  FCCNO       Character     22
  96.    58  FCCNAME     Character     30
  97.    59  FCCEXPDATE  Character      5
  98. ** Total **                     815
  99.  
  100. * Note that all 'Ship to' and 'Bill to' addresses are assumed to be the same.
  101.  
  102.  
  103.  
  104.  
  105.       Logic behind creation of FCUSTNO field in SourceMate [TM] file:
  106.                              two step process
  107.  
  108.  
  109. Thσá prograφ firs⌠ look≤ t∩ seσ iµ yo⌡ havσ entereΣ thi≤ phrasσ int∩ eithe≥ ì
  110. COMMENT▒ o≥ COMMENT2║á  "CUSTNO='«á  Iµ thi≤ codσ i≤ present¼á theε thσ teε ìècharacter≤ followinτ "CUSTNO=ó arσ placeΣ int∩ thσ correspondinτ SourceMatσ ì
  111. [TM▌ record«  
  112.      
  113. Secondly¼á thσá prograφá wil∞ creatσ ß fou≥ characte≥ codσ iε FCUSTN╧á tha⌠ ì
  114. adhere≤ t∩ thσ followinτ logic:
  115.  
  116. 1)  The fourth character will be a '1'
  117. 2⌐á Thσ firs⌠ threσ character≤ wil∞ bσ takeε froφ thσ firs⌠ lette≥ oµá eacΦ ì
  118. namσ froφ thσ compan∙ namσ o≥ PROSPEC╘ field.
  119. 3)  The following articles are dropped from the company name during step 2:
  120.  
  121.                        A AN IN OR & THE OF FOR WITH
  122.  
  123. 4⌐  Iµ thσ resultinτ word≤ iε thσ compan∙ namσ numbe≥ les≤ thaε 3¼ theε thσ ì
  124. remaininτ character≤ arσ takeε a≤ needeΣ froφ thσ las⌠ completσ worΣ iε thσ ì
  125. compan∙ name« 
  126.  
  127.                                  Examples:
  128.                           [taken from test data]
  129.        
  130.     FCUSTNO     Company name:
  131.  
  132.          ATS1   Accounting & Tax Service           
  133.          ADD1   Addmaster/Marchant                 
  134.          FDS1   Fourcolor Data Systems             
  135.          LLE1   Lolir Lectronics                   
  136.          MDC1   Micro Distribution Center          
  137.          NAI1   North American Investment Corp.    
  138.          PBO1   P.O. BOX                           
  139.          REV1   Rex Evilsizor                      
  140.          SEL1   Sabet Electronics                  
  141.          TCP1   Texas Commerce Plumbing            
  142.  
  143.  
  144.                                ==============
  145.                                |  OPTION 2: |
  146.                                ==============
  147.  
  148.           2) Additional selection criteria specific to SourceMate [TM]:
  149.  
  150.  
  151. A⌠ thi≤ menu¼á yo⌡ caε ente≥ value≤ whicΦ wil∞ bσ placeΣ iε al∞ record≤ no≈ ì
  152. beinτá outputteΣá t∩ thσ SourceMatσ [TM▌ custome≥ file«á  Thesσ arσá field≤ ì
  153. ove≥á anΣ beyonΣ thσ minima∞ field≤ beinτ createΣ iε eacΦá SourceMatσá [TM▌ ì
  154. custome≥ record.
  155.  
  156. These optional fields are:
  157.  
  158. FTERM
  159. FARACC
  160. FCCLASS
  161. FSALESPN
  162. FTERR
  163. FINDUSTRY
  164. FTAXCODE1
  165. èFTAXCODE2
  166. FPAYTYPE
  167. FDISRATE
  168. FTAXRATE1
  169. FTAXRATE2
  170. FCRLIMIT
  171. FCURORDER
  172. FDISCNT
  173. FFINCHG
  174.  
  175.  
  176.  
  177.